PATOLOGIA

"192.168.0.1:sipop"

PATOLOGIA

Descriptions

PATOLOGIAS REGISTRADAS EN EL SISTEMA

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		ID_PATOLOGIA		CHAR (2)
		NOMBRE_PATOLOGIA		CHAR (30)
		SUB_TIPO_PATO		CHAR (2)
		DESCRIPCION		CHAR (240)

Triggers

There are no triggers for table PATOLOGIA

Indices

There are no indices for table PATOLOGIA

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
SUBTIPOPATO	INTEG_272	SUB_TIPO_PATO	ID_SUB_TIPO_PATO	RESTRICT	RESTRICT

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PATOPOREXPE	INTEG_273	PATOLOGIA	ID_PATOLOGIA	RESTRICT	RESTRICT

Definition


CREATE TABLE PATOLOGIA (
    ID_PATOLOGIA CHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE_PATOLOGIA CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    SUB_TIPO_PATO CHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DESCRIPCION CHAR (240) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE PATOLOGIA ADD PRIMARY KEY (ID_PATOLOGIA);
ALTER TABLE PATOLOGIA ADD  FOREIGN KEY (SUB_TIPO_PATO) REFERENCES SUBTIPOPATO (ID_SUB_TIPO_PATO);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 04:58 p.m.